Pivot Grid Overview

The Pivot Grid Standard (Windows App Only) new Component within the Dashboard Maintenance Unit that allows you to create a pivot table, utilizing data from any existing and new Data Adapters to perform multi-dimensional analysis. At runtime, the user can customize the layout of the report using simple drag-and-drop operations and conditional formatting based on their analysis requirements. In the Pivot Grid, data can be summarized, calculated fields (text and decimal) can be added and displayed in a cross-tabular format that can be sorted, grouped and filtered. The Pivot Grid also supports drill-down (to view the underlying Data Adapter Results Table). The resulting output can be printed or exported to various file formats (such as PDF, XLS and XLSX).

The Pivot Grid uses the entire table contents from the Data Adapter that is returned to the client machine.  The Pivot Grid can handle much larger data sets compared to Adapter based “standard” Pivot Grid.  The Paging controls allow the pivoting to be efficiently managed for the client. The Pivot Grid Component can be used to better analyze data utilizing functionality such as data filtering, value formatting, sorting and grouping data.

Conditional Formatting is also supported here to allow the user to change the appearance of individual cells based on specific conditions to help with further analyzing the data. This feature helps to highlight important information, identify trends and exceptions, and compare data using the collection of format rules. The user can change appearances of Pivot Grid Control cells depending upon cell data or an expression.

The user can manage the Pivot Grid layout by changing the layout of fields, measure, adding calculated items and groups.

At runtime the user can Save the Pivot Grid as they make changes and then choose to Restore back to the original component settings when needed.

Also, at runtime the user has the choices of Printing and Exporting data displayed within the Pivot Grid. Data can be exported and printed from a Pivot Grid to a file or various file formats (such as PDF, XLS and XLSX).